CREATE SCHEMA [Addin]
AUTHORIZATION [dbo]
GO
GRANT ALTER ON SCHEMA:: [Addin] TO [FRANKLINSQUARE\tmcguinness] WITH GRANT OPTION
GRANT CONTROL ON SCHEMA:: [Addin] TO [FRANKLINSQUARE\tmcguinness] WITH GRANT OPTION
GRANT TAKE OWNERSHIP ON SCHEMA:: [Addin] TO [FRANKLINSQUARE\tmcguinness] WITH GRANT OPTION
GRANT VIEW DEFINITION ON SCHEMA:: [Addin] TO [FRANKLINSQUARE\tmcguinness] WITH GRANT OPTION
GRANT REFERENCES ON SCHEMA:: [Addin] TO [FRANKLINSQUARE\tmcguinness] WITH GRANT OPTION
GRANT SELECT ON SCHEMA:: [Addin] TO [FRANKLINSQUARE\tmcguinness] WITH GRANT OPTION
GRANT INSERT ON SCHEMA:: [Addin] TO [FRANKLINSQUARE\tmcguinness] WITH GRANT OPTION
GRANT DELETE ON SCHEMA:: [Addin] TO [FRANKLINSQUARE\tmcguinness] WITH GRANT OPTION
GRANT UPDATE ON SCHEMA:: [Addin] TO [FRANKLINSQUARE\tmcguinness] WITH GRANT OPTION
GRANT EXECUTE ON SCHEMA:: [Addin] TO [FRANKLINSQUARE\tmcguinness] WITH GRANT OPTION
GRANT VIEW CHANGE TRACKING ON SCHEMA:: [Addin] TO [FRANKLINSQUARE\tmcguinness] WITH GRANT OPTION
GRANT EXECUTE ON SCHEMA:: [Addin] TO [reportingUser]
GRANT EXECUTE ON SCHEMA:: [Addin] TO [ssrsuser]
GO
